Sam Swain ✭✭✭✭

Overview

Overview

Roles	Member
Badges	9

About Me

About Me

Not much happening here, yet.

Analytics

78

Posts

361

Visits

224

Points

Jan 14, 2022

Join Date

Jan 30, 2025

Last Active

Reactions

• Vote Up 3

  3
• Awesome 1

  1

• Activity
• Discussions27
• Comments51

• Re: Countifs Date range clash formula with Distinct value criteria

  Sam Swain

  07/03/24
  Okay I think I have the answer, it's =COUNTIFS(Start:Start, Start@row >= @cell, Finish:Finish, Finish@row <= @cell, 👤:👤, HAS(@cell, 👤@row))
  1 ·

• Conditional Dropdown menus

  Sam Swain

  10/13/23
  Hi community, Has anyone come up with a smart workaround for the conditional dropdown menus? Ideally I'd like my sheet to have a dropdown list in Column1, and based upon what is selected in column 1,…
  1 ·

• Vote up target lines for Smartsheet charts

  Sam Swain

  08/25/23
  Hi all, Smartsheet developers review the most voted up community posts to make changes to the platform. I am desperate for them to add target lines to Smartsheet charts. If you’re like me, could you …
  1 ·